-
Re: Display Pie Chart in a Dashboard
Hello @1996mustang This is typically a problem when you have more information on a sheet than just numeric values, and text to describe those values. If you create a report from that sheet with the f…1 · -
Re: Function to change value of dropdown (to "Completed) when checkbox is checked.
Hello @Christopher Warren You are so close! Try this: =IF(CMPLT@row = 1, "Completed")1 · -
Re: How do I concatenate contact names from different sheets?
This is for if you have a column of names and want distinct ones. =JOIN(DISTINCT({Contact (Sheet1)}), " & ") If this isn't the answer can you share an image? It's hard to follow a text …1 · -
Re: When does a column reference need to be in [brackets]?
Hi Mike, It is needed because you are using numbers in your column name. If you use only letters and no spaces it will not require brackets. This might be because it needs to differentiate between co…1 ·